Excel Workbook Second Edition: 155 exercises with solutions and comments by Alberto Clerici

Author:Alberto Clerici [Clerici, Alberto]
Language: eng
Format: azw3
Publisher: Egea
Published: 2017-03-28T04:00:00+00:00

Unit 10. Database functions and chart options

Topics of this unit:

Use and creation of templates, SUM function with 3D references, Database functions: DSUM; DMIN; DMAX; DCOUNT; DAVERAGE, commenting, Compare and Merge Workbooks command, advanced chart options.

This unit is specifically dedicated to the preparation of the ECDL Advanced Spreadsheets certification.

EXERCISE 10.1 - Payroll office

You are a professional and you are collaborating with the reorganization of a small business payroll office (Logos3 Ltd.). Values are expressed in US dollars.

You are asked to:

1.Create a new template of expense statement for the employees of the company. Entries can be invented at will. Save the new template with the name Expenses report.xltx.

2.Look, among the models available in Excel, for an invoice template. Create a new workbook from the template chosen, and save the file with the name Invoice.xlsx. Customize the file created by the template using your own data (name etc.).

Apply the appropriate formatting and organize data in an appropriate manner, in order to ensure maximum readability and give a neat and professional appearance to the worksheets.

Save the changes and close the file.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.